|
This page last changed on Feb 06, 2009 by cmd0219.
| Name |
Description/Objective
|
Expected Result
|
Status
|
Written By
|
Execution Steps
|
UPDATE 1
|
Update a row from a simple SELECT * FROM TABLE query with and without primary keys.
|
|
|
Chris |
|
UPDATE 2
|
Update multiple rows from a simple SELECT * FROM TABLE query with and without primary keys.
|
|
|
Chris |
|
UPDATE 3
|
Update a row from a nested select statement. SELECT * FROM TABLE1 WHERE X IN (SELECT Y FROM TABLE2) query.
|
|
|
Chris |
|
UPDATE 4
|
Update row(s) from an INNER JOIN query on more than 1 table.
|
|
|
|
|
UPDATE 5
|
Update row(s) from a LEFT OUTER JOIN query on more than 1 table.
|
|
|
|
|
UPDATE 6
|
Update row(s) from a RIGHT OUTER JOIN query on more than 1 table.
|
|
|
|
|
REFRESH ADD
|
Refresh servlet displays new rows added to underlying datasource.
|
|
|
Chris |
1. Call refresh servlet
2. Add a new row
3. Call refresh servlet
4. Check that new row is present
|
REFRESH DELETE
|
Refresh servlet does not display rows removed from underlying datasource.
|
|
|
Chris
|
1. Call refresh servlet
2. Delete a row
3. Call refresh servlet
4. Check that rows have been removed.
|
DATASOURCE OFF
|
Plugin provides appropriate error message for datasource related errors. |
|
|
Chris
|
|
LOCKED TABLES
|
Appropriate message should be displayed for errors related to locked tables.
|
|
|
Chris
|
|
SQL INJECTION
|
Plugin prevents sql injection attempts. Values are appropriately escaped when passed to plugin.
|
|
|
Chris
|
|
DATA STRESS TEST
|
Plugin performs normally with extremely large data sets.
|
|
|
|
|
UPDATE USER PROVIDED
|
The where clause used in the update statements only contain columns specified by the user provided info.
|
|
|
|
|
UPDATE USER PROVIDED
|
Exception message is displayed when invalid columns are specified by the user for identifyingColumns parameter.
|
|
|
|
|
SERVLET SECURITY
|
Servlet only runs updates / refreshes for a valid confluence session.
|
|
|
|
|
SERVLET POST
|
Servlet returns errors for invalid POST parameters (incorrect naming, wrong amounts, etc.)
|
|
|
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
|
